Easy2Siksha.com
GNDU Question Paper 2024
B.B.A 2
nd
Semester
Paper-BBA-206: Computer Based Accounting System
Time Allowed: 3 Hours Maximum Marks: 100
Note: Attempt Five questions in all, selecting at least One question from each section. The
Fifth question may be attempted from any section. All questions carry equal marks.
SECTION-A
1. What is Computerized Accounting? How does a Computer help in Accounting ?
2. What is difference between Trial Balance and Balance Sheet? How can you prepare
both using Accounting Package ?
SECTION-B
3. What is data, database, DBMS? Which are various advantages of DBMS?
4. What is SQL? Which are various SQL statements to retrieve data from database ?
SECTION-C
5. What are issues in storing and maintaining huge transaction data ?
6. Explain the process of Accounts Management using Tally.
Easy2Siksha.com
SECTION-D
7. What are Accounting Reports ? Give examples. Explain various steps involved in
Creating Accounting Reports.
8. Explain with an example preparation and compilation of complete Balance Sheet for a
firm.
GNDU Answer Paper 2024
B.B.A 2
nd
Semester
Paper-BBA-206: Computer Based Accounting System
Time Allowed: 3 Hours Maximum Marks: 100
Note: Attempt Five questions in all, selecting at least One question from each section. The
Fifth question may be attempted from any section. All questions carry equal marks.
SECTION-A
1. What is Computerized Accounting? How does a Computer help in Accounting ?
Ans: 1. What is Computerized Accounting? How does a Computer help in Accounting?
Accounting is an important part of every business. It helps organizations record, organize,
and analyze their financial transactions such as income, expenses, purchases, and sales. In
earlier times, accountants maintained records manually in books and ledgers. This method is
known as manual accounting. However, with the development of technology, most
businesses today use computerized accounting, which makes accounting work easier,
faster, and more accurate.
Meaning of Computerized Accounting
Computerized Accounting refers to the use of computers and accounting software to
record, store, process, and manage financial transactions. Instead of writing entries in
Easy2Siksha.com
physical books, accountants enter the data into a computer system, and the software
automatically processes the information.
In simple words, computerized accounting means doing accounting work with the help of
computers and specialized accounting programs.
Some common accounting software used by businesses include programs that help record
transactions, prepare financial statements, calculate taxes, and generate reports quickly.
For example, imagine a shopkeeper who sells many products daily. If he writes every
transaction in a notebook, it will take time and mistakes may occur. But if he uses a
computer with accounting software, he can enter the details once and the system will
automatically update the ledger, calculate totals, and prepare reports.
Thus, computerized accounting makes the accounting process more efficient and
organized.
Features of Computerized Accounting
Computerized accounting systems have several important features that make them very
useful in modern business:
1. Automation of Calculations
The computer automatically performs calculations such as totals, balances, and
taxes. This reduces the chances of mathematical errors.
2. Large Data Storage
Computers can store a huge amount of financial data for many years. This
information can be accessed whenever required.
3. Quick Processing
Financial transactions can be processed very quickly compared to manual methods.
4. Easy Retrieval of Information
Users can easily search and find any financial record within seconds.
5. Generation of Reports
The system can automatically generate financial reports such as profit and loss
statements, balance sheets, and sales reports.
How a Computer Helps in Accounting
Computers play a major role in simplifying accounting tasks. They help accountants perform
their work faster, more accurately, and with less effort. Some important ways in which
computers help in accounting are explained below.
1. Faster Recording of Transactions
In manual accounting, each transaction must be written in different books such as the
journal, ledger, and cash book. This takes a lot of time.
Easy2Siksha.com
With computerized accounting, the accountant enters the transaction only once. The
software automatically records it in the appropriate accounts. This saves a great amount of
time and effort.
2. Accuracy in Calculations
Manual accounting involves many calculations, such as totals and balances. Human errors
can easily occur while calculating.
Computers perform calculations automatically and accurately. As a result, the chances of
errors are greatly reduced.
3. Automatic Preparation of Financial Statements
Preparing financial statements manually is a time-consuming task. Accountants must collect
data from different books and prepare statements step by step.
In computerized accounting, the software automatically generates financial statements like:
• Profit and Loss Account
• Balance Sheet
• Trial Balance
• Cash Flow Statement
These reports can be prepared instantly.
4. Easy Data Storage and Security
Computers allow businesses to store large amounts of financial information safely. The data
can be saved for many years without occupying physical space.
In addition, accounting systems often provide password protection and backups, which
keep financial information safe from unauthorized access or loss.
5. Quick Data Retrieval
If a business needs information about a past transaction, finding it in manual records may
take a long time.
In a computerized system, users can search for the required information within seconds.
This helps managers make quick decisions.
6. Better Financial Analysis
Computers help in analyzing financial data easily. Accounting software can generate charts,
graphs, and detailed reports that show the financial performance of a business.
Easy2Siksha.com
These analyses help managers understand whether the business is making profit or loss and
what improvements are needed.
7. Reduction in Paperwork
Manual accounting requires many registers, files, and documents. This creates a lot of
paperwork.
Computerized accounting reduces the use of paper because most records are stored
digitally.
8. Improved Efficiency and Productivity
Since many tasks are automated, accountants can complete their work faster. This increases
productivity and allows businesses to focus on other important activities.
Conclusion
Computerized accounting has transformed the traditional way of maintaining financial
records. It uses computers and accounting software to record, process, and manage
financial transactions efficiently.
Compared to manual accounting, computerized accounting is faster, more accurate, and
more reliable. It reduces errors, saves time, stores large amounts of data, and generates
financial reports instantly.
Computers help accountants perform complex tasks with ease and provide valuable
financial information for decision-making. Because of these advantages, most modern
businesses now rely on computerized accounting systems.
2. What is difference between Trial Balance and Balance Sheet? How can you prepare
both using Accounting Package ?
Ans: Introduction
In accounting, two important statements often confuse students: the Trial Balance and the
Balance Sheet. Both are prepared from the books of accounts, but they serve very different
purposes. The Trial Balance is like a checkpoint—it ensures that debits and credits are
balanced. The Balance Sheet, on the other hand, is a financial snapshot—it shows the
financial position of a business at a particular date.
With modern accounting packages (like Tally, QuickBooks, or Zoho Books), preparing both
has become much easier.
Easy2Siksha.com
Difference Between Trial Balance and Balance Sheet
Aspect
Trial Balance
Balance Sheet
Definition
A statement showing all ledger
balances (debit and credit) at a
particular date.
A statement showing assets,
liabilities, and capital of a business at
a particular date.
Purpose
To check the arithmetical accuracy
of accounts and ensure debits =
credits.
To show the financial position of the
business (what it owns and owes).
Nature
Internal document, used by
accountants.
External document, used by
stakeholders like investors, banks,
and regulators.
Contents
Contains balances of all accounts
(real, nominal, personal).
Contains only assets, liabilities, and
capital accounts.
Timing
Prepared before final accounts,
usually at the end of an accounting
period.
Prepared after final accounts, as part
of financial statements.
Format
Two columns: Debit and Credit.
Two sides: Assets and Liabilities (or
vertical format).
Usefulness
Detects errors in posting and
balancing.
Shows solvency, liquidity, and overall
financial health.
Analogy: Think of the Trial Balance as a rehearsal before a play—it checks if everything is in
order. The Balance Sheet is the final performance—it presents the financial story to the
audience.
How to Prepare Trial Balance Using Accounting Package
Modern accounting packages simplify the process:
1. Record Transactions: Enter all vouchers (sales, purchases, payments, receipts) into
the system.
2. Ledger Posting: The software automatically posts entries into respective ledgers.
3. Generate Trial Balance:
o Go to the “Reports” section.
o Select “Trial Balance.”
o The system displays all ledger balances with debit and credit totals.
4. Check Accuracy: If debit and credit totals match, accounts are arithmetically correct.
If not, errors must be located and corrected.
Example in Tally:
• Gateway of Tally → Reports → Trial Balance → Select Date → View/Print.
How to Prepare Balance Sheet Using Accounting Package
1. Complete Trial Balance: Ensure all accounts are balanced and adjusted.
Easy2Siksha.com
2. Final Accounts: The package automatically prepares the Profit & Loss Account and
Balance Sheet.
3. Generate Balance Sheet:
o Go to “Reports” → “Financial Statements” → “Balance Sheet.”
o The system classifies accounts into Assets and Liabilities.
4. View Financial Position: The Balance Sheet shows capital, reserves, loans, creditors,
fixed assets, current assets, etc.
5. Export/Print: Most packages allow exporting to PDF, Excel, or direct printing.
Example in QuickBooks:
• Reports → Company & Financial → Balance Sheet Standard → Select Date →
Generate Report.
Everyday Analogy
Imagine running a shop:
• The Trial Balance is like checking your notebook to ensure every entry of sales and
purchases is correctly recorded—your math is right.
• The Balance Sheet is like preparing a summary for yourself and outsiders: how much
stock you have, how much money you owe, and how much profit you’ve made.
Importance of Both
• Trial Balance: Ensures accuracy, detects errors, and prepares ground for final
accounts.
• Balance Sheet: Shows financial strength, helps in decision-making, and builds trust
with stakeholders.
Conclusion
The Trial Balance and Balance Sheet are interconnected but distinct. The Trial Balance
checks accuracy, while the Balance Sheet shows financial position. With accounting
packages, preparing both is straightforward—transactions are entered once, and the system
automatically generates these reports.
Easy2Siksha.com
SECTION-B
3. What is data, database, DBMS? Which are various advantages of DBMS?
Ans: Introduction
In today’s digital world, information is everywhere. Whenever we use a smartphone, shop
online, withdraw money from an ATM, or even check our college results, data is being
stored and managed somewhere in a computer system. Behind all these activities there is a
system that stores, organizes, and manages information efficiently. To understand this
system, we must first learn about data, database, and DBMS (Database Management
System). These three terms are closely related and form the foundation of modern
information systems.
Let us understand these concepts step-by-step in a simple and clear way.
1. What is Data?
Data refers to raw facts and figures that are collected for reference or analysis. These facts
by themselves may not have much meaning until they are processed or organized.
In simple words, data is unprocessed information.
For example:
• A student's marks: 75, 82, 90
• Names: Rahul, Simran, Aman
• Phone numbers: 9876543210, 9123456789
• Dates: 15/03/2026
These are all examples of data.
Individually, these values do not tell us much. But when they are organized, they can
become meaningful information.
For example:
Name
Marks
Rahul
75
Simran
82
Aman
90
Now the data becomes meaningful and useful.
Types of Data
Easy2Siksha.com
Data can exist in different forms, such as:
1. Numeric Data – numbers like marks, salary, age
2. Text Data – names, addresses, messages
3. Date and Time Data – dates, timestamps
4. Multimedia Data – images, videos, audio files
All organizations collect and store large amounts of data for decision-making and record
keeping.
2. What is a Database?
A database is an organized collection of related data that is stored in a structured way so
that it can be easily accessed, managed, and updated.
In simple terms, a database is a place where data is stored in an organized form.
Think of a database like a digital filing cabinet. In an office, files are stored in cabinets with
proper labels so that they can be easily found when needed. Similarly, in a computer
system, a database stores data in an organized manner.
Example of a Database
A college database might contain information such as:
• Student names
• Roll numbers
• Subjects
• Marks
• Attendance records
Example table:
Roll No
Name
Course
Marks
101
Rahul
B.Sc
78
102
Simran
BA
85
103
Aman
B.Com
80
Here, all the student information is stored in a structured format. This makes it easy to
search, update, or analyze the data.
Real-Life Examples of Databases
Databases are used everywhere in modern life:
• Banks store customer account information.
• Hospitals store patient medical records.
• Universities store student details and exam results.
Easy2Siksha.com
• E-commerce websites store product and customer information.
• Social media platforms store user profiles and posts.
Without databases, managing large amounts of information would be extremely difficult.
3. What is DBMS (Database Management System)?
A DBMS (Database Management System) is a software system that helps users create,
manage, and interact with databases.
In simple words, DBMS is the software that manages the database.
It acts as a bridge between the user and the database, allowing users to store, retrieve,
modify, and delete data easily.
Example
Suppose a college wants to manage student records.
Instead of storing information manually in files, the college uses a DBMS. With the help of
this system:
• New student records can be added.
• Existing records can be updated.
• Student information can be searched quickly.
• Reports can be generated easily.
Examples of Popular DBMS
Some well-known DBMS software include:
• MySQL
• Oracle Database
• Microsoft SQL Server
• PostgreSQL
• Microsoft Access
These systems help organizations handle large amounts of data efficiently.
Advantages of DBMS
Using a DBMS provides many advantages compared to traditional file systems. Some of the
major advantages are explained below.
Easy2Siksha.com
1. Reduced Data Redundancy
Data redundancy means storing the same data multiple times in different places.
In traditional systems, the same information might be repeated in many files. This wastes
storage space and can cause confusion.
A DBMS reduces redundancy by storing data in a centralized database, where each piece of
information is stored only once.
For example:
Instead of storing a student’s address in multiple files, the DBMS stores it in one place and
allows all departments to access it.
2. Improved Data Consistency
When data is duplicated in many places, it can lead to inconsistencies.
For example:
If a student changes their phone number but only some files are updated, different records
will show different phone numbers.
DBMS helps maintain data consistency by ensuring that changes are updated everywhere
automatically.
3. Better Data Security
Data security is very important, especially for sensitive information like bank accounts,
medical records, or personal details.
A DBMS provides security features such as:
• Password protection
• User authentication
• Access control
This means only authorized users can access or modify certain data.
For example:
• Students can view their results but cannot modify them.
• Teachers can update marks but cannot access financial records.
Easy2Siksha.com
4. Easy Data Access
DBMS makes it easy to search and retrieve information quickly.
Users can perform complex queries to find specific data.
For example:
• Find students who scored above 80 marks.
• List all customers from a particular city.
• Show products with low stock.
This saves a lot of time and effort.
5. Data Sharing
A DBMS allows multiple users to access the same database at the same time.
For example, in a university:
• The admission department can add student records.
• Teachers can update marks.
• The accounts department can manage fee details.
All departments can share the same database without conflicts.
6. Backup and Recovery
Data loss can occur due to system failures, power outages, or human errors.
DBMS systems provide backup and recovery mechanisms to protect data.
If the system crashes, the database can be restored from a backup.
This ensures that important information is not permanently lost.
7. Better Data Integrity
Data integrity means maintaining the accuracy and correctness of data.
DBMS enforces rules and constraints to ensure that incorrect data cannot be entered.
Easy2Siksha.com
For example:
• A student roll number must be unique.
• Marks cannot exceed 100.
• A phone number must contain valid digits.
These rules help maintain reliable data.
Conclusion
Data is the basic building block of any information system. It represents raw facts and
figures that become meaningful when organized and processed. A database stores this data
in a structured and organized manner so that it can be easily accessed and managed.
However, managing large databases manually would be very difficult. This is where a
Database Management System (DBMS) plays an important role.
A DBMS provides tools and software that allow users to create, store, update, and retrieve
data efficiently. It also offers several advantages such as reduced data redundancy,
improved consistency, better security, easy data access, data sharing, backup and recovery,
and improved data integrity.
In modern organizations, DBMS has become an essential technology for managing large
volumes of data. From banks and hospitals to universities and online platforms, DBMS helps
ensure that information is stored safely, accessed quickly, and managed effectively.
Therefore, understanding the concepts of data, database, and DBMS is very important in
today’s digital and information-driven world.
4. What is SQL? Which are various SQL statements to retrieve data from database ?
Ans: In today’s digital world, almost every application we use—such as banking apps,
shopping websites, social media platforms, and university portals—stores a large amount of
data. This data is usually stored in a database. A database is simply an organized collection
of information that can be easily accessed, managed, and updated.
To interact with this data, we need a special language called SQL.
Meaning of SQL
SQL stands for Structured Query Language. It is a standard programming language used to
communicate with databases. With SQL, users can store data, modify it, delete it, and most
importantly, retrieve information from the database.
Easy2Siksha.com
In simple words, SQL acts like a bridge between the user and the database. If the database
is like a huge digital library, then SQL is the language we use to ask the librarian to find
specific books.
For example, imagine a college database that stores information about students such as:
• Student Name
• Roll Number
• Course
• Marks
• Address
If someone wants to find the marks of a particular student or list all students in a specific
course, SQL is used to retrieve that information quickly.
SQL is widely used in database systems such as MySQL, Oracle, SQL Server, PostgreSQL, and
SQLite.
Types of SQL Statements
SQL contains different types of statements that perform different functions. Some
statements are used to create databases, some to modify data, and others to retrieve
information.
The SQL statements used specifically to retrieve data from a database mainly belong to
Data Query Language (DQL). The most important statement in this category is the SELECT
statement. However, several clauses are used with SELECT to retrieve data in different
ways.
1. SELECT Statement
The SELECT statement is the most important SQL command used to retrieve data from one
or more tables in a database.
It allows the user to select specific columns or all columns from a table.
Syntax
SELECT column_name
FROM table_name;
Example
Suppose there is a table called Students.
RollNo
Name
Course
Marks
Easy2Siksha.com
1
Aman
BSc
80
2
Ravi
BA
75
3
Simran
BSc
90
If we want to see all students' names, we can write:
SELECT Name
FROM Students;
If we want to display all columns, we use:
SELECT *
FROM Students;
The asterisk (*) symbol means all columns.
2. WHERE Clause
The WHERE clause is used to filter records based on a condition. It helps retrieve only the
data that satisfies a specific requirement.
Syntax
SELECT column_name
FROM table_name
WHERE condition;
Example
To display students who scored more than 80 marks:
SELECT Name, Marks
FROM Students
WHERE Marks > 80;
This query will only show students whose marks are greater than 80.
The WHERE clause can use different operators such as:
• = equal to
• > greater than
• < less than
• >= greater than or equal to
• <= less than or equal to
• != not equal to
Easy2Siksha.com
3. ORDER BY Clause
The ORDER BY clause is used to sort the retrieved data in ascending or descending order.
Syntax
SELECT column_name
FROM table_name
ORDER BY column_name ASC/DESC;
• ASC means ascending order (default)
• DESC means descending order
Example
To display students sorted by marks in descending order:
SELECT Name, Marks
FROM Students
ORDER BY Marks DESC;
This will show the highest marks first.
4. GROUP BY Clause
The GROUP BY clause is used to group rows that have the same values in a particular
column. It is commonly used with aggregate functions like COUNT, SUM, AVG, MAX, and
MIN.
Syntax
SELECT column_name, aggregate_function(column_name)
FROM table_name
GROUP BY column_name;
Example
To count how many students are in each course:
SELECT Course, COUNT(*)
FROM Students
GROUP BY Course;
This will group students according to their course.
Easy2Siksha.com
5. HAVING Clause
The HAVING clause is used to filter grouped data. It works similarly to the WHERE clause
but is used after GROUP BY.
Syntax
SELECT column_name, aggregate_function(column_name)
FROM table_name
GROUP BY column_name
HAVING condition;
Example
To show courses that have more than one student:
SELECT Course, COUNT(*)
FROM Students
GROUP BY Course
HAVING COUNT(*) > 1;
6. DISTINCT Statement
The DISTINCT keyword is used to remove duplicate values from the result.
Syntax
SELECT DISTINCT column_name
FROM table_name;
Example
If we want to display all unique courses taken by students:
SELECT DISTINCT Course
FROM Students;
This will show each course only once.
Conclusion
SQL is a powerful language used to communicate with databases. It allows users to store,
modify, and retrieve information efficiently. Among its many functions, retrieving data is
one of the most common tasks, and this is mainly done using the SELECT statement.
Easy2Siksha.com
Several clauses such as WHERE, ORDER BY, GROUP BY, HAVING, and DISTINCT work
together with SELECT to make data retrieval more flexible and meaningful. These
statements allow users to filter, sort, group, and analyze data easily.
Understanding these SQL statements is very important for anyone working with databases,
whether they are students, programmers, data analysts, or database administrators. With
SQL, even large databases containing millions of records can be searched and managed
quickly and efficiently.
SECTION-C
5. What are issues in storing and maintaining huge transaction data ?
Ans: Issues in Storing and Maintaining Huge Transaction Data
In today’s digital world, organizations generate a massive amount of transaction data every
day. Transaction data refers to the information produced when any activity or exchange
takes place. For example, when a person uses a debit card in a supermarket, books a ticket
online, transfers money through mobile banking, or makes an online purchase, the system
records a transaction. These records include details such as date, time, amount, customer
information, product details, and payment method.
Large organizations such as banks, e-commerce companies, supermarkets, and government
departments process millions of transactions daily. Managing and storing such huge
amounts of data is not an easy task. There are many challenges and issues that
organizations face when dealing with large transaction databases. Understanding these
issues helps us realize why advanced database systems and technologies are needed.
Let us discuss the major issues involved in storing and maintaining huge transaction data.
1. Storage Capacity Problems
One of the biggest issues is storage capacity. Every transaction creates new data, and when
millions of transactions occur every day, the amount of data grows extremely fast.
For example, imagine a large online shopping website like Amazon. Every second thousands
of customers are placing orders, searching products, making payments, and leaving reviews.
All these activities generate data that must be stored safely.
Over time, the storage requirement becomes very large. Organizations need powerful
servers, large storage devices, and cloud systems to store this information. Managing such
large storage infrastructure becomes expensive and complex.
Easy2Siksha.com
2. Data Security and Privacy
Another major issue is security. Transaction data often contains sensitive information such
as:
• Customer names
• Credit or debit card details
• Bank account numbers
• Addresses and contact details
If this information falls into the wrong hands, it can lead to fraud, identity theft, or financial
loss. Therefore, companies must ensure strong security measures such as encryption,
authentication systems, firewalls, and secure access controls.
Maintaining security for huge datasets is challenging because hackers constantly try to
exploit system weaknesses. Even a small security failure can cause serious problems for
organizations and customers.
3. Data Consistency and Accuracy
When huge volumes of transaction data are stored, it becomes difficult to maintain data
consistency and accuracy.
For example, consider a banking system where thousands of people are transferring money
at the same time. The system must update balances correctly for every transaction. If the
database fails to update correctly, it may show incorrect balances.
Ensuring that every transaction is recorded accurately and consistently across the system is
very important. Database systems use special mechanisms like transaction management
and locking systems to maintain consistency, but managing this for massive data volumes is
still challenging.
4. Data Retrieval Speed
Another issue is retrieving data quickly. When databases become very large, searching for
specific information can become slow.
For instance, if a company wants to find all transactions made by a particular customer in
the past five years, the system must search through millions or even billions of records. If
the system is not properly optimized, this process can take a long time.
Organizations must use techniques such as indexing, database optimization, and advanced
search algorithms to ensure fast data retrieval.
Easy2Siksha.com
5. System Performance and Processing Power
Handling huge transaction data requires high processing power. As the number of
transactions increases, the system must process and update information quickly.
If the system is not powerful enough, it may become slow or even crash. For example,
during big online sales events or festival seasons, e-commerce websites experience
extremely high transaction volumes. If the system cannot handle the load, customers may
face payment failures or delayed services.
Therefore, organizations must invest in powerful servers, distributed databases, and
scalable systems to maintain good performance.
6. Data Backup and Recovery
Another important issue is data backup and recovery. Transaction data is extremely
valuable, and losing it can cause serious financial and operational problems.
Imagine if a bank suddenly loses records of customer transactions due to a system failure. It
would be very difficult to restore accurate account balances.
To prevent such situations, companies create regular backups of their data. However,
backing up very large datasets takes time, storage space, and careful planning. Recovery
systems must also be designed so that data can be restored quickly in case of failure.
7. Data Maintenance and Management
Maintaining huge transaction databases requires continuous monitoring and management.
Over time, databases may contain outdated, duplicate, or unnecessary data.
For example, transaction logs from many years ago may no longer be required for daily
operations. Organizations must decide which data should be archived, deleted, or moved to
long-term storage.
Database administrators regularly perform tasks such as:
• Cleaning unnecessary data
• Updating database structures
• Monitoring system performance
• Ensuring smooth database operations
Managing such large systems requires skilled professionals and advanced tools.
Easy2Siksha.com
8. Scalability Challenges
As organizations grow, the number of transactions also increases. Systems must be able to
scale, meaning they should handle increasing data volumes without losing performance.
If a company’s system is not scalable, it may struggle to manage future growth. Upgrading
systems, migrating databases, or expanding infrastructure can be complex and expensive.
Modern organizations often use cloud computing and distributed databases to solve
scalability issues.
Conclusion
Storing and maintaining huge transaction data is a complex task that requires advanced
technology, careful planning, and strong management systems. Organizations must deal
with challenges such as large storage requirements, data security risks, maintaining
accuracy, fast data retrieval, system performance, backup management, and scalability.
As businesses and digital services continue to grow, the amount of transaction data will
keep increasing. Therefore, companies must adopt modern database technologies, cloud
systems, and strong security practices to manage their data effectively.
6. Explain the process of Accounts Management using Tally.
Ans: Introduction
Tally is one of the most widely used accounting software packages in India and beyond. It
simplifies the complex process of managing accounts by automating entries, generating
reports, and ensuring accuracy. Instead of manually writing ledgers and balancing books,
Tally allows businesses to record transactions digitally and instantly prepare financial
statements.
Step-by-Step Process of Accounts Management in Tally
1. Creating a Company
• The first step is to create a company in Tally.
• You enter basic details like company name, address, financial year, and currency.
• This sets up the environment where all transactions will be recorded.
Analogy: Think of this as opening a new notebook before you start writing accounts.
2. Creating Ledgers and Groups
Easy2Siksha.com
• In Tally, every transaction is recorded under a ledger.
• Ledgers are grouped into categories like Assets, Liabilities, Income, and Expenses.
• Examples: Cash, Bank, Sales, Purchases, Rent, Salaries.
Why important? Proper grouping ensures that reports like the Balance Sheet and Profit &
Loss Account are generated correctly.
3. Recording Transactions (Voucher Entry)
• Transactions are entered using vouchers.
• Common voucher types include:
o Payment Voucher (for expenses and payments).
o Receipt Voucher (for income and receipts).
o Sales Voucher (for sales transactions).
o Purchase Voucher (for purchases).
o Contra Voucher (for cash/bank transfers).
Example: If you pay office rent of ₹10,000, you record it in a Payment Voucher under the
Rent ledger.
4. Maintaining Inventory (Optional)
• Tally also allows inventory management.
• You can create stock items, units of measure, and track purchases and sales.
• This is useful for businesses dealing with goods.
Example: A shop can track how many units of a product were sold and how many remain in
stock.
5. Generating Trial Balance
• Once transactions are recorded, Tally automatically prepares a Trial Balance.
• This shows debit and credit balances of all ledgers.
• It helps check the accuracy of accounts before preparing final statements.
6. Preparing Financial Statements
• Tally can instantly generate:
o Profit & Loss Account – shows income and expenses, and whether the
business made a profit or loss.
o Balance Sheet – shows assets, liabilities, and capital, giving a snapshot of
financial position.
o Cash Flow Statement – shows inflow and outflow of cash.
Analogy: This is like pressing a button and having your entire financial report card ready.
7. Bank Reconciliation
Easy2Siksha.com
• Tally allows reconciliation of bank statements with company records.
• This ensures that all deposits, withdrawals, and charges are correctly recorded.
8. Tax Management (GST, TDS, etc.)
• Tally supports GST, TDS, and other tax compliance.
• You can configure tax rates, record tax-related transactions, and generate returns.
Example: When you sell goods with GST, Tally automatically calculates and records the tax.
9. Audit and Compliance Tools
• Tally provides audit features like checking for errors, unusual entries, or missing
information.
• This helps maintain transparency and compliance with regulations.
10. Reports and Analysis
• Managers can generate various reports:
o Day Book (daily transactions).
o Ledger Reports.
o Stock Summary.
o Ratio Analysis.
• These reports help in decision-making and performance evaluation.
Everyday Analogy
Imagine running a household budget:
• You create a notebook (company).
• You list categories like groceries, rent, electricity (ledgers).
• You record every expense and income (voucher entries).
• At the end of the month, you check if your notebook balances (trial balance).
• Finally, you prepare a summary of savings, expenses, and assets (balance sheet and
P&L).
Tally does all of this automatically, saving time and reducing errors.
Benefits of Using Tally for Accounts Management
• Accuracy: Reduces human error.
• Speed: Instant report generation.
• Compliance: Handles GST, TDS, and other taxes.
• Flexibility: Suitable for small shops and large companies alike.
• Integration: Combines accounting with inventory and payroll.
Conclusion
Easy2Siksha.com
Accounts management in Tally follows a clear process: create company → create ledgers →
record transactions → generate trial balance → prepare financial statements → reconcile
banks → manage taxes → audit and analyze reports.
SECTION-D
7. What are Accounting Reports ? Give examples. Explain various steps involved in
Creating Accounting Reports.
Ans: Accounting Reports: Meaning, Examples, and Steps Involved in Creating Accounting
Reports
Accounting is often called the language of business. Just like any language helps people
communicate ideas, accounting helps a business communicate its financial information to
different people such as managers, owners, investors, banks, and government authorities.
However, the financial information of a business is usually very large and complex. To make
it easier to understand, this information is organized and presented in the form of
Accounting Reports.
In simple words, accounting reports are documents that present the financial information
of a business in a clear and organized way. These reports help people understand the
financial position and performance of a business. They show how much money the business
earns, how much it spends, what assets it owns, and what liabilities it owes.
Accounting reports play an important role in decision-making. Managers use them to plan
business activities, investors use them to decide whether to invest, and banks use them to
evaluate whether a company can repay loans. Without accounting reports, it would be very
difficult to understand the financial condition of any organization.
Meaning of Accounting Reports
An Accounting Report is a structured presentation of financial data that summarizes the
financial activities of a business over a specific period. These reports are prepared using the
information recorded in accounting books such as journals, ledgers, and trial balances.
Accounting reports help answer important questions such as:
• Is the business making a profit or a loss?
• What are the total assets and liabilities of the company?
• How much cash is available in the business?
• How efficiently is the business using its resources?
Easy2Siksha.com
By providing such information, accounting reports help both internal users (managers,
employees, owners) and external users (investors, creditors, government agencies).
Examples of Accounting Reports
There are many types of accounting reports used in business. Some of the most common
examples include the following:
1. Income Statement (Profit and Loss Account)
The Income Statement shows the profit or loss of a business during a specific period, such
as a month, quarter, or year.
It includes:
• Revenue or sales earned by the business
• Expenses such as salaries, rent, electricity, and raw materials
If the total revenue is greater than the expenses, the business earns a profit. If expenses are
higher than revenue, the business suffers a loss.
2. Balance Sheet
The Balance Sheet shows the financial position of a business at a specific point in time.
It contains three main elements:
• Assets – things the business owns (cash, buildings, machinery, inventory)
• Liabilities – money the business owes (loans, creditors)
• Owner’s Equity – the owner’s investment in the business
The balance sheet follows the basic accounting equation:
Assets = Liabilities + Owner’s Equity
3. Cash Flow Statement
The Cash Flow Statement shows the movement of cash into and out of the business.
It is divided into three parts:
• Cash from operating activities
Easy2Siksha.com
• Cash from investing activities
• Cash from financing activities
This report helps managers understand whether the business has enough cash to meet its
daily expenses.
4. Trial Balance
A Trial Balance is a report that lists all ledger accounts and their balances. It helps ensure
that the total debit equals total credit, which indicates that the accounting records are
mathematically correct.
5. Accounts Receivable and Accounts Payable Reports
These reports provide details about:
• Accounts Receivable – money customers owe to the business.
• Accounts Payable – money the business owes to suppliers.
These reports help businesses manage payments and collections effectively.
Steps Involved in Creating Accounting Reports
Creating accounting reports involves several systematic steps. These steps ensure that the
financial information is accurate, reliable, and useful for decision-making.
1. Collecting Financial Data
The first step is to collect financial information related to the business transactions.
These transactions may include:
• Sales
• Purchases
• Payments
• Receipts
• Expenses
• Investments
All these transactions are supported by documents such as invoices, bills, receipts, and
vouchers.
Easy2Siksha.com
2. Recording Transactions
After collecting the financial data, the next step is to record the transactions in the
accounting books.
This is usually done in the Journal, which is known as the book of original entry. Each
transaction is recorded with details such as date, account names, debit amount, and credit
amount.
For example:
• Payment of rent
• Purchase of goods
• Sale of products
Recording transactions accurately is essential because all accounting reports depend on this
information.
3. Posting to Ledger Accounts
The next step is posting the journal entries into ledger accounts.
A Ledger is a book that contains all individual accounts such as:
• Cash Account
• Sales Account
• Purchase Account
• Salary Account
Posting helps classify transactions into their respective accounts so that the balances of
each account can be calculated.
4. Preparing the Trial Balance
Once all ledger accounts are prepared, the next step is to prepare the trial balance.
The trial balance lists all accounts with their debit or credit balances. The main purpose of
the trial balance is to check whether the accounting records are correct.
If the total debit equals the total credit, it indicates that the accounts are balanced.
5. Making Adjustments
Easy2Siksha.com
Before preparing final reports, some adjustments are made to ensure accuracy.
These adjustments may include:
• Outstanding expenses
• Prepaid expenses
• Depreciation of assets
• Accrued income
Adjustments help present a true and fair view of financial statements.
6. Preparing Financial Statements
After adjustments, the final accounting reports are prepared.
These include:
• Income Statement
• Balance Sheet
• Cash Flow Statement
These reports summarize all financial activities of the business and show its overall financial
condition.
7. Analyzing and Interpreting the Reports
The final step is analysis and interpretation.
Managers, investors, and stakeholders study these reports to understand:
• Profitability of the business
• Financial stability
• Cash position
• Efficiency of operations
This analysis helps in planning future strategies and making important business decisions.
Conclusion
Accounting reports are essential tools that help businesses present their financial
information in an organized and understandable manner. They provide valuable insights
into the financial performance and position of an organization. Reports such as the Income
Easy2Siksha.com
Statement, Balance Sheet, Cash Flow Statement, and Trial Balance help managers,
investors, and other stakeholders make informed decisions.
The process of creating accounting reports involves several steps, including collecting data,
recording transactions, posting to ledger accounts, preparing the trial balance, making
adjustments, preparing financial statements, and analyzing the results. Each step plays an
important role in ensuring that the financial reports are accurate and reliable.
In conclusion, accounting reports act as a financial mirror of a business, reflecting its
financial health and guiding future planning and decision-making. Without these reports,
managing and evaluating business performance would become extremely difficult.
8. Explain with an example preparation and compilation of complete Balance Sheet for a
firm.
Ans: Introduction
A Balance Sheet is one of the most important financial statements of a firm. It shows the
financial position at a particular date—what the firm owns (assets) and what it owes
(liabilities), along with the owner’s capital. Preparing and compiling a Balance Sheet may
sound technical, but once you understand the process, it feels like organizing a detailed list
of possessions and obligations.
Steps in Preparation of a Balance Sheet
1. Collect Ledger Balances
• Start with the Trial Balance, which lists all ledger accounts with debit and credit
balances.
• From this, identify which accounts belong to assets, liabilities, and capital.
2. Classify Accounts
• Assets: Cash, bank balance, stock, debtors, furniture, machinery, land, etc.
• Liabilities: Creditors, loans, outstanding expenses.
• Capital: Owner’s capital, reserves, retained earnings.
3. Adjustments
• Make adjustments for items like depreciation, outstanding expenses, prepaid
expenses, accrued income, etc.
• These ensure the Balance Sheet reflects the true financial position.
4. Arrange in Order
Easy2Siksha.com
• Assets are shown on one side, liabilities and capital on the other.
• Assets are usually arranged as fixed assets first, then current assets.
• Liabilities are arranged as long-term liabilities first, then current liabilities.
5. Balance Both Sides
• The total of assets must equal the total of liabilities plus capital.
• This equality reflects the accounting equation:
Assets = Liabilities + Capital
Example: Balance Sheet of XYZ Traders
Suppose XYZ Traders has the following balances on 31st March 2025:
• Capital: ₹1,00,000
• Loan from Bank: ₹50,000
• Creditors: ₹20,000
• Cash in Hand: ₹10,000
• Bank Balance: ₹15,000
• Debtors: ₹25,000
• Stock: ₹30,000
• Furniture: ₹20,000
• Machinery: ₹70,000
Step 1: Classify
• Liabilities: Loan (₹50,000), Creditors (₹20,000).
• Capital: ₹1,00,000.
• Assets: Cash (₹10,000), Bank (₹15,000), Debtors (₹25,000), Stock (₹30,000),
Furniture (₹20,000), Machinery (₹70,000).
Step 2: Arrange in Balance Sheet
Balance Sheet of XYZ Traders as on 31st March 2025
Liabilities
Amount (₹)
Assets
Amount (₹)
Capital
1,00,000
Fixed Assets:
Loan from Bank
50,000
Machinery
70,000
Creditors
20,000
Furniture
20,000
Current Assets:
Stock
30,000
Debtors
25,000
Bank Balance
15,000
Cash in Hand
10,000
Total
1,70,000
Total
1,70,000
Easy2Siksha.com
Step 3: Verify
• Both sides equal ₹1,70,000.
• The Balance Sheet is complete and balanced.
Compilation Using Accounting Packages (like Tally, QuickBooks, Zoho Books)
Modern accounting software makes Balance Sheet preparation effortless:
1. Enter Transactions: Record all vouchers (sales, purchases, payments, receipts).
2. Ledger Posting: The system automatically updates ledgers.
3. Trial Balance: Generated instantly by the software.
4. Adjustments: Enter depreciation, outstanding expenses, etc.
5. Generate Balance Sheet:
o Go to “Reports” → “Financial Statements” → “Balance Sheet.”
o The software compiles all data and presents the Balance Sheet in proper
format.
6. Export/Print: You can export to PDF/Excel or print directly for stakeholders.
Analogy: It’s like feeding ingredients into a mixer—the accounting package blends
everything and serves you a perfectly prepared Balance Sheet.
Conclusion
Preparing a Balance Sheet involves collecting ledger balances, classifying them into assets,
liabilities, and capital, making adjustments, and arranging them systematically. The Balance
Sheet shows the financial position of a firm at a specific date. With accounting packages,
this process becomes quick and accurate, as the software compiles everything
automatically.
“This paper has been carefully prepared for educational purposes. If you notice any mistakes or
have suggestions, feel free to share your feedback.”
